Overview
Brought to you by YData
Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 881666 |
| Missing cells | 30 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 440828 |
| Duplicate rows (%) | 50.0% |
| Total size in memory | 80.7 MiB |
| Average record size in memory | 96.0 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 4 |
| Dataset has 440828 (50.0%) duplicate rows | Duplicates |
CustomerID is highly overall correlated with cancelou | High correlation |
cancelou is highly overall correlated with CustomerID and 1 other fields | High correlation |
ligacoes_callcenter is highly overall correlated with cancelou | High correlation |
ligacoes_callcenter has 139750 (15.9%) zeros | Zeros |
dias_atraso has 33808 (3.8%) zeros | Zeros |
Reproduction
| Analysis started | 2025-11-21 00:14:53.701700 |
|---|---|
| Analysis finished | 2025-11-21 00:15:30.958358 |
| Duration | 37.26 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
CustomerID
Real number (ℝ)
High correlation
| Distinct | 440832 |
|---|---|
| Distinct (%) | 50.0% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 225398.67 |
| Minimum | 2 |
|---|---|
| Maximum | 449999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 22050.15 |
| Q1 | 113621.75 |
| median | 226125.5 |
| Q3 | 337739.25 |
| 95-th percentile | 425905.85 |
| Maximum | 449999 |
| Range | 449997 |
| Interquartile range (IQR) | 224117.5 |
Descriptive statistics
| Standard deviation | 129531.85 |
|---|---|
| Coefficient of variation (CV) | 0.57467884 |
| Kurtosis | -1.2006439 |
| Mean | 225398.67 |
| Median Absolute Deviation (MAD) | 112049.5 |
| Skewness | -0.018485792 |
| Sum | 1.9872589 × 1011 |
| Variance | 1.6778499 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 449999 | 2 | < 0.1% |
| 449243 | 2 | < 0.1% |
| 449242 | 2 | < 0.1% |
| 449241 | 2 | < 0.1% |
| 449240 | 2 | < 0.1% |
| 449239 | 2 | < 0.1% |
| 449238 | 2 | < 0.1% |
| 449237 | 2 | < 0.1% |
| 449236 | 2 | < 0.1% |
| 449235 | 2 | < 0.1% |
| Other values (440822) | 881644 |
| Value | Count | Frequency (%) |
| 2 | 2 | |
| 3 | 2 | |
| 4 | 2 | |
| 5 | 2 | |
| 6 | 2 | |
| 8 | 2 | |
| 9 | 2 | |
| 10 | 2 | |
| 11 | 2 | |
| 12 | 2 |
| Value | Count | Frequency (%) |
| 449999 | 2 | |
| 449998 | 2 | |
| 449997 | 2 | |
| 449996 | 2 | |
| 449995 | 2 | |
| 449994 | 2 | |
| 449993 | 2 | |
| 449992 | 2 | |
| 449991 | 2 | |
| 449990 | 2 |
idade
Real number (ℝ)
| Distinct | 48 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 39.373153 |
| Minimum | 18 |
|---|---|
| Maximum | 65 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 MiB |
Quantile statistics
| Minimum | 18 |
|---|---|
| 5-th percentile | 20 |
| Q1 | 29 |
| median | 39 |
| Q3 | 48 |
| 95-th percentile | 61 |
| Maximum | 65 |
| Range | 47 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 12.442362 |
|---|---|
| Coefficient of variation (CV) | 0.31601133 |
| Kurtosis | -0.86485526 |
| Mean | 39.373153 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 0.1620154 |
| Sum | 34713892 |
| Variance | 154.81238 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 27054 | 3.1% |
| 42 | 25156 | 2.9% |
| 40 | 24834 | 2.8% |
| 48 | 24758 | 2.8% |
| 47 | 24738 | 2.8% |
| 46 | 24736 | 2.8% |
| 44 | 24688 | 2.8% |
| 49 | 24662 | 2.8% |
| 41 | 24628 | 2.8% |
| 43 | 24596 | 2.8% |
| Other values (38) | 631814 |
| Value | Count | Frequency (%) |
| 18 | 16438 | |
| 19 | 16146 | |
| 20 | 19106 | |
| 21 | 19148 | |
| 22 | 19278 | |
| 23 | 19026 | |
| 24 | 18930 | |
| 25 | 19294 | |
| 26 | 19384 | |
| 27 | 18944 |
| Value | Count | Frequency (%) |
| 65 | 10920 | |
| 64 | 10992 | |
| 63 | 11120 | |
| 62 | 10576 | |
| 61 | 10814 | |
| 60 | 10860 | |
| 59 | 11146 | |
| 58 | 10746 | |
| 57 | 10722 | |
| 56 | 10954 |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.8646378 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Female |
|---|---|
| 2nd row | Female |
| 3rd row | Female |
| 4th row | Male |
| 5th row | Male |
Common Values
| Value | Count | Frequency (%) |
| Male | 500504 | |
| Female | 381160 | |
| (Missing) | 2 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| male | 500504 | |
| female | 381160 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1262824 | |
| a | 881664 | |
| l | 881664 | |
| M | 500504 | 11.7% |
| F | 381160 | 8.9% |
| m | 381160 | 8.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4288976 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1262824 | |
| a | 881664 | |
| l | 881664 | |
| M | 500504 | 11.7% |
| F | 381160 | 8.9% |
| m | 381160 | 8.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4288976 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1262824 | |
| a | 881664 | |
| l | 881664 | |
| M | 500504 | 11.7% |
| F | 381160 | 8.9% |
| m | 381160 | 8.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4288976 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1262824 | |
| a | 881664 | |
| l | 881664 | |
| M | 500504 | 11.7% |
| F | 381160 | 8.9% |
| m | 381160 | 8.9% |
tempo_como_cliente
Real number (ℝ)
| Distinct | 60 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.256312 |
| Minimum | 1 |
|---|---|
| Maximum | 60 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 16 |
| median | 32 |
| Q3 | 46 |
| 95-th percentile | 58 |
| Maximum | 60 |
| Range | 59 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 17.255713 |
|---|---|
| Coefficient of variation (CV) | 0.55207131 |
| Kurtosis | -1.1925219 |
| Mean | 31.256312 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | -0.061399502 |
| Sum | 27557534 |
| Variance | 297.75964 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 32 | 15656 | 1.8% |
| 49 | 15630 | 1.8% |
| 56 | 15624 | 1.8% |
| 55 | 15554 | 1.8% |
| 33 | 15540 | 1.8% |
| 52 | 15537 | 1.8% |
| 30 | 15500 | 1.8% |
| 47 | 15494 | 1.8% |
| 48 | 15474 | 1.8% |
| 57 | 15470 | 1.8% |
| Other values (50) | 726184 |
| Value | Count | Frequency (%) |
| 1 | 12814 | |
| 2 | 13150 | |
| 3 | 12834 | |
| 4 | 13212 | |
| 5 | 13338 | |
| 6 | 15408 | |
| 7 | 15138 | |
| 8 | 15340 | |
| 9 | 15068 | |
| 10 | 15348 |
| Value | Count | Frequency (%) |
| 60 | 15316 | |
| 59 | 15194 | |
| 58 | 15338 | |
| 57 | 15470 | |
| 56 | 15624 | |
| 55 | 15554 | |
| 54 | 15212 | |
| 53 | 15330 | |
| 52 | 15537 | |
| 51 | 15188 |
frequencia_uso
Real number (ℝ)
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.807496 |
| Minimum | 1 |
|---|---|
| Maximum | 30 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 9 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 30 |
| Range | 29 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 8.5862414 |
|---|---|
| Coefficient of variation (CV) | 0.54317532 |
| Kurtosis | -1.1758168 |
| Mean | 15.807496 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | -0.043474089 |
| Sum | 13936884 |
| Variance | 73.723542 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11 | 30622 | 3.5% |
| 29 | 30568 | 3.5% |
| 20 | 30516 | 3.5% |
| 25 | 30474 | 3.5% |
| 30 | 30464 | 3.5% |
| 21 | 30410 | 3.4% |
| 19 | 30408 | 3.4% |
| 12 | 30358 | 3.4% |
| 26 | 30268 | 3.4% |
| 15 | 30258 | 3.4% |
| Other values (20) | 577317 |
| Value | Count | Frequency (%) |
| 1 | 27594 | |
| 2 | 27266 | |
| 3 | 27686 | |
| 4 | 27098 | |
| 5 | 27432 | |
| 6 | 27492 | |
| 7 | 27110 | |
| 8 | 27450 | |
| 9 | 27540 | |
| 10 | 30180 |
| Value | Count | Frequency (%) |
| 30 | 30464 | |
| 29 | 30568 | |
| 28 | 30024 | |
| 27 | 30242 | |
| 26 | 30268 | |
| 25 | 30474 | |
| 24 | 30076 | |
| 23 | 30144 | |
| 22 | 30010 | |
| 21 | 30410 |
ligacoes_callcenter
Real number (ℝ)
High correlation Zeros
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.6044366 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 139750 |
| Zeros (%) | 15.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 6 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.0702161 |
|---|---|
| Coefficient of variation (CV) | 0.85178808 |
| Kurtosis | -0.74591454 |
| Mean | 3.6044366 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.66680737 |
| Sum | 3177902 |
| Variance | 9.4262271 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 139750 | |
| 1 | 138952 | |
| 2 | 133142 | |
| 3 | 105458 | |
| 4 | 77500 | |
| 5 | 49836 | 5.7% |
| 10 | 47800 | 5.4% |
| 7 | 47740 | 5.4% |
| 9 | 47260 | 5.4% |
| 8 | 47118 | 5.3% |
| Value | Count | Frequency (%) |
| 0 | 139750 | |
| 1 | 138952 | |
| 2 | 133142 | |
| 3 | 105458 | |
| 4 | 77500 | |
| 5 | 49836 | 5.7% |
| 6 | 47108 | 5.3% |
| 7 | 47740 | 5.4% |
| 8 | 47118 | 5.3% |
| 9 | 47260 | 5.4% |
| Value | Count | Frequency (%) |
| 10 | 47800 | 5.4% |
| 9 | 47260 | 5.4% |
| 8 | 47118 | 5.3% |
| 7 | 47740 | 5.4% |
| 6 | 47108 | 5.3% |
| 5 | 49836 | 5.7% |
| 4 | 77500 | |
| 3 | 105458 | |
| 2 | 133142 | |
| 1 | 138952 |
dias_atraso
Real number (ℝ)
Zeros
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.965722 |
| Minimum | 0 |
|---|---|
| Maximum | 30 |
| Zeros | 33808 |
| Zeros (%) | 3.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 6 |
| median | 12 |
| Q3 | 19 |
| 95-th percentile | 28 |
| Maximum | 30 |
| Range | 30 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 8.2580578 |
|---|---|
| Coefficient of variation (CV) | 0.63691463 |
| Kurtosis | -0.89567996 |
| Mean | 12.965722 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.26740667 |
| Sum | 11431410 |
| Variance | 68.195519 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 34396 | 3.9% |
| 11 | 34370 | 3.9% |
| 20 | 34350 | 3.9% |
| 13 | 34190 | 3.9% |
| 14 | 34156 | 3.9% |
| 10 | 34102 | 3.9% |
| 7 | 34054 | 3.9% |
| 18 | 34054 | 3.9% |
| 3 | 34050 | 3.9% |
| 1 | 34042 | 3.9% |
| Other values (21) | 539900 |
| Value | Count | Frequency (%) |
| 0 | 33808 | |
| 1 | 34042 | |
| 2 | 33644 | |
| 3 | 34050 | |
| 4 | 33876 | |
| 5 | 33488 | |
| 6 | 33908 | |
| 7 | 34054 | |
| 8 | 33784 | |
| 9 | 33738 |
| Value | Count | Frequency (%) |
| 30 | 17180 | |
| 29 | 16892 | |
| 28 | 16598 | |
| 27 | 16356 | |
| 26 | 16766 | |
| 25 | 16724 | |
| 24 | 16650 | |
| 23 | 16646 | |
| 22 | 16908 | |
| 21 | 17340 |
assinatura
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Memory size | 6.7 MiB |
| Standard | |
|---|---|
| Premium | |
| Basic |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.6893942 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Standard |
|---|---|
| 2nd row | Basic |
| 3rd row | Basic |
| 4th row | Standard |
| 5th row | Basic |
Common Values
| Value | Count | Frequency (%) |
| Standard | 298255 | |
| Premium | 297354 | |
| Basic | 286052 | |
| (Missing) | 5 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| standard | 298255 | |
| premium | 297354 | |
| basic | 286052 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 882562 | |
| d | 596510 | |
| r | 595609 | |
| m | 594708 | |
| i | 583406 | |
| S | 298255 | 5.1% |
| n | 298255 | 5.1% |
| t | 298255 | 5.1% |
| e | 297354 | 5.0% |
| P | 297354 | 5.0% |
| Other values (4) | 1155510 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5897778 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 882562 | |
| d | 596510 | |
| r | 595609 | |
| m | 594708 | |
| i | 583406 | |
| S | 298255 | 5.1% |
| n | 298255 | 5.1% |
| t | 298255 | 5.1% |
| e | 297354 | 5.0% |
| P | 297354 | 5.0% |
| Other values (4) | 1155510 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5897778 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 882562 | |
| d | 596510 | |
| r | 595609 | |
| m | 594708 | |
| i | 583406 | |
| S | 298255 | 5.1% |
| n | 298255 | 5.1% |
| t | 298255 | 5.1% |
| e | 297354 | 5.0% |
| P | 297354 | 5.0% |
| Other values (4) | 1155510 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5897778 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 882562 | |
| d | 596510 | |
| r | 595609 | |
| m | 594708 | |
| i | 583406 | |
| S | 298255 | 5.1% |
| n | 298255 | 5.1% |
| t | 298255 | 5.1% |
| e | 297354 | 5.0% |
| P | 297354 | 5.0% |
| Other values (4) | 1155510 |
duracao_contrato
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Memory size | 6.7 MiB |
| Annual | |
|---|---|
| Quarterly | |
| Monthly |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.3989325 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Annual |
|---|---|
| 2nd row | Monthly |
| 3rd row | Quarterly |
| 4th row | Monthly |
| 5th row | Monthly |
Common Values
| Value | Count | Frequency (%) |
| Annual | 354396 | |
| Quarterly | 353060 | |
| Monthly | 174207 | |
| (Missing) | 3 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| annual | 354396 | |
| quarterly | 353060 | |
| monthly | 174207 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 882999 | |
| l | 881663 | |
| u | 707456 | |
| a | 707456 | |
| r | 706120 | |
| y | 527267 | |
| t | 527267 | |
| A | 354396 | |
| Q | 353060 | 5.4% |
| e | 353060 | 5.4% |
| Other values (3) | 522621 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6523365 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 882999 | |
| l | 881663 | |
| u | 707456 | |
| a | 707456 | |
| r | 706120 | |
| y | 527267 | |
| t | 527267 | |
| A | 354396 | |
| Q | 353060 | 5.4% |
| e | 353060 | 5.4% |
| Other values (3) | 522621 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6523365 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 882999 | |
| l | 881663 | |
| u | 707456 | |
| a | 707456 | |
| r | 706120 | |
| y | 527267 | |
| t | 527267 | |
| A | 354396 | |
| Q | 353060 | 5.4% |
| e | 353060 | 5.4% |
| Other values (3) | 522621 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6523365 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 882999 | |
| l | 881663 | |
| u | 707456 | |
| a | 707456 | |
| r | 706120 | |
| y | 527267 | |
| t | 527267 | |
| A | 354396 | |
| Q | 353060 | 5.4% |
| e | 353060 | 5.4% |
| Other values (3) | 522621 |
total_gasto
Real number (ℝ)
| Distinct | 68363 |
|---|---|
| Distinct (%) | 7.8% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 631.61622 |
| Minimum | 100 |
|---|---|
| Maximum | 1000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 MiB |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 177 |
| Q1 | 480 |
| median | 661 |
| Q3 | 830 |
| 95-th percentile | 965.8985 |
| Maximum | 1000 |
| Range | 900 |
| Interquartile range (IQR) | 350 |
Descriptive statistics
| Standard deviation | 240.80286 |
|---|---|
| Coefficient of variation (CV) | 0.3812487 |
| Kurtosis | -0.75149138 |
| Mean | 631.61622 |
| Median Absolute Deviation (MAD) | 172.55 |
| Skewness | -0.4571733 |
| Sum | 5.5687329 × 108 |
| Variance | 57986.02 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 234 | 538 | 0.1% |
| 432 | 534 | 0.1% |
| 703 | 532 | 0.1% |
| 139 | 530 | 0.1% |
| 845 | 530 | 0.1% |
| 581 | 530 | 0.1% |
| 133 | 526 | 0.1% |
| 534 | 524 | 0.1% |
| 613 | 524 | 0.1% |
| 269 | 522 | 0.1% |
| Other values (68353) | 876374 |
| Value | Count | Frequency (%) |
| 100 | 200 | |
| 100.02 | 2 | < 0.1% |
| 100.06 | 2 | < 0.1% |
| 100.07 | 2 | < 0.1% |
| 100.08 | 2 | < 0.1% |
| 100.09 | 4 | < 0.1% |
| 100.11 | 2 | < 0.1% |
| 100.12 | 4 | < 0.1% |
| 100.13 | 4 | < 0.1% |
| 100.16 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 1000 | 222 | |
| 999.99 | 10 | < 0.1% |
| 999.98 | 4 | < 0.1% |
| 999.97 | 6 | < 0.1% |
| 999.96 | 14 | < 0.1% |
| 999.95 | 4 | < 0.1% |
| 999.94 | 10 | < 0.1% |
| 999.93 | 8 | < 0.1% |
| 999.92 | 12 | < 0.1% |
| 999.91 | 4 | < 0.1% |
meses_ultima_interacao
Real number (ℝ)
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.480868 |
| Minimum | 1 |
|---|---|
| Maximum | 30 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 7 |
| median | 14 |
| Q3 | 22 |
| 95-th percentile | 29 |
| Maximum | 30 |
| Range | 29 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.5962028 |
|---|---|
| Coefficient of variation (CV) | 0.59362483 |
| Kurtosis | -1.15376 |
| Mean | 14.480868 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.17677375 |
| Sum | 12767260 |
| Variance | 73.894703 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 33828 | 3.8% |
| 14 | 33542 | 3.8% |
| 8 | 33524 | 3.8% |
| 15 | 33500 | 3.8% |
| 6 | 33492 | 3.8% |
| 1 | 33454 | 3.8% |
| 12 | 33444 | 3.8% |
| 3 | 33422 | 3.8% |
| 5 | 33420 | 3.8% |
| 10 | 33370 | 3.8% |
| Other values (20) | 546668 |
| Value | Count | Frequency (%) |
| 1 | 33454 | |
| 2 | 33326 | |
| 3 | 33422 | |
| 4 | 33140 | |
| 5 | 33420 | |
| 6 | 33492 | |
| 7 | 33828 | |
| 8 | 33524 | |
| 9 | 33064 | |
| 10 | 33370 |
| Value | Count | Frequency (%) |
| 30 | 25308 | |
| 29 | 25134 | |
| 28 | 25508 | |
| 27 | 25574 | |
| 26 | 25646 | |
| 25 | 25206 | |
| 24 | 25786 | |
| 23 | 25288 | |
| 22 | 25380 | |
| 21 | 25290 |
cancelou
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 6.7 MiB |
| 1.0 | |
|---|---|
| 0.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 499998 | |
| 0.0 | 381666 | |
| (Missing) | 2 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 499998 | |
| 0.0 | 381666 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1263330 | |
| . | 881664 | |
| 1 | 499998 | 18.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2644992 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1263330 | |
| . | 881664 | |
| 1 | 499998 | 18.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2644992 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1263330 | |
| . | 881664 | |
| 1 | 499998 | 18.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2644992 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1263330 | |
| . | 881664 | |
| 1 | 499998 | 18.9% |
Interactions
Correlations
| CustomerID | assinatura | cancelou | dias_atraso | duracao_contrato | frequencia_uso | idade | ligacoes_callcenter | meses_ultima_interacao | sexo | tempo_como_cliente | total_gasto | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CustomerID | 1.000 | 0.014 | 0.949 | -0.243 | 0.291 | 0.038 | -0.163 | -0.470 | -0.125 | 0.166 | 0.044 | 0.334 |
| assinatura | 0.014 | 1.000 | 0.021 | 0.005 | 0.007 | 0.001 | 0.007 | 0.009 | 0.003 | 0.003 | 0.039 | 0.008 |
| cancelou | 0.949 | 0.021 | 1.000 | 0.402 | 0.434 | 0.059 | 0.432 | 0.615 | 0.172 | 0.175 | 0.078 | 0.496 |
| dias_atraso | -0.243 | 0.005 | 0.402 | 1.000 | 0.112 | -0.013 | 0.051 | 0.146 | 0.039 | 0.063 | -0.015 | -0.104 |
| duracao_contrato | 0.291 | 0.007 | 0.434 | 0.112 | 1.000 | 0.016 | 0.122 | 0.169 | 0.047 | 0.068 | 0.023 | 0.136 |
| frequencia_uso | 0.038 | 0.001 | 0.059 | -0.013 | 0.016 | 1.000 | -0.006 | -0.021 | -0.005 | 0.013 | -0.027 | 0.017 |
| idade | -0.163 | 0.007 | 0.432 | 0.051 | 0.122 | -0.006 | 1.000 | 0.169 | 0.026 | 0.066 | -0.010 | -0.070 |
| ligacoes_callcenter | -0.470 | 0.009 | 0.615 | 0.146 | 0.169 | -0.021 | 0.169 | 1.000 | 0.075 | 0.097 | -0.027 | -0.199 |
| meses_ultima_interacao | -0.125 | 0.003 | 0.172 | 0.039 | 0.047 | -0.005 | 0.026 | 0.075 | 1.000 | 0.156 | -0.007 | -0.052 |
| sexo | 0.166 | 0.003 | 0.175 | 0.063 | 0.068 | 0.013 | 0.066 | 0.097 | 0.156 | 1.000 | 0.011 | 0.077 |
| tempo_como_cliente | 0.044 | 0.039 | 0.078 | -0.015 | 0.023 | -0.027 | -0.010 | -0.027 | -0.007 | 0.011 | 1.000 | 0.017 |
| total_gasto | 0.334 | 0.008 | 0.496 | -0.104 | 0.136 | 0.017 | -0.070 | -0.199 | -0.052 | 0.077 | 0.017 | 1.000 |
Missing values
Sample
| CustomerID | idade | sexo | tempo_como_cliente | frequencia_uso | ligacoes_callcenter | dias_atraso | assinatura | duracao_contrato | total_gasto | meses_ultima_interacao | cancelou | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2.0 | 30.0 | Female | 39.0 | 14.0 | 5.0 | 18.0 | Standard | Annual | 932.0 | 17.0 | 1.0 |
| 1 | 3.0 | 65.0 | Female | 49.0 | 1.0 | 10.0 | 8.0 | Basic | Monthly | 557.0 | 6.0 | 1.0 |
| 2 | 4.0 | 55.0 | Female | 14.0 | 4.0 | 6.0 | 18.0 | Basic | Quarterly | 185.0 | 3.0 | 1.0 |
| 3 | 5.0 | 58.0 | Male | 38.0 | 21.0 | 7.0 | 7.0 | Standard | Monthly | 396.0 | 29.0 | 1.0 |
| 4 | 6.0 | 23.0 | Male | 32.0 | 20.0 | 5.0 | 8.0 | Basic | Monthly | 617.0 | 20.0 | 1.0 |
| 5 | 8.0 | 51.0 | Male | 33.0 | 25.0 | 9.0 | 26.0 | Premium | Annual | 129.0 | 8.0 | 1.0 |
| 6 | 9.0 | 58.0 | Female | 49.0 | 12.0 | 3.0 | 16.0 | Standard | Quarterly | 821.0 | 24.0 | 1.0 |
| 7 | 10.0 | 55.0 | Female | 37.0 | 8.0 | 4.0 | 15.0 | Premium | Annual | 445.0 | 30.0 | 1.0 |
| 8 | 11.0 | 39.0 | Male | 12.0 | 5.0 | 7.0 | 4.0 | Standard | Quarterly | 969.0 | 13.0 | 1.0 |
| 9 | 12.0 | 64.0 | Female | 3.0 | 25.0 | 2.0 | 11.0 | Standard | Quarterly | 415.0 | 29.0 | 1.0 |
| CustomerID | idade | sexo | tempo_como_cliente | frequencia_uso | ligacoes_callcenter | dias_atraso | assinatura | duracao_contrato | total_gasto | meses_ultima_interacao | cancelou | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 881656 | 449990.0 | 48.0 | Male | 11.0 | 27.0 | 1.0 | 18.0 | Standard | Annual | 618.28 | 5.0 | 0.0 |
| 881657 | 449991.0 | 41.0 | Male | 46.0 | 25.0 | 3.0 | 2.0 | Standard | Quarterly | 619.79 | 15.0 | 0.0 |
| 881658 | 449992.0 | 41.0 | Male | 27.0 | 20.0 | 2.0 | 12.0 | Standard | Quarterly | 634.17 | 27.0 | 0.0 |
| 881659 | 449993.0 | 49.0 | Male | 37.0 | 23.0 | 4.0 | 16.0 | Standard | Annual | 666.65 | 30.0 | 0.0 |
| 881660 | 449994.0 | 45.0 | Male | 6.0 | 25.0 | 2.0 | 15.0 | Basic | Annual | 837.00 | 2.0 | 0.0 |
| 881661 | 449995.0 | 42.0 | Male | 54.0 | 15.0 | 1.0 | 3.0 | Premium | Annual | 716.38 | 8.0 | 0.0 |
| 881662 | 449996.0 | 25.0 | Female | 8.0 | 13.0 | 1.0 | 20.0 | Premium | Annual | 745.38 | 2.0 | 0.0 |
| 881663 | 449997.0 | 26.0 | Male | 35.0 | 27.0 | 1.0 | 5.0 | Standard | Quarterly | 977.31 | 9.0 | 0.0 |
| 881664 | 449998.0 | 28.0 | Male | 55.0 | 14.0 | 2.0 | 0.0 | Standard | Quarterly | 602.55 | 2.0 | 0.0 |
| 881665 | 449999.0 | 31.0 | Male | 48.0 | 20.0 | 1.0 | 14.0 | Premium | Quarterly | 567.77 | 21.0 | 0.0 |
Duplicate rows
Most frequently occurring
| CustomerID | idade | sexo | tempo_como_cliente | frequencia_uso | ligacoes_callcenter | dias_atraso | assinatura | duracao_contrato | total_gasto | meses_ultima_interacao | cancelou | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2.0 | 30.0 | Female | 39.0 | 14.0 | 5.0 | 18.0 | Standard | Annual | 932.0 | 17.0 | 1.0 | 2 |
| 1 | 3.0 | 65.0 | Female | 49.0 | 1.0 | 10.0 | 8.0 | Basic | Monthly | 557.0 | 6.0 | 1.0 | 2 |
| 2 | 4.0 | 55.0 | Female | 14.0 | 4.0 | 6.0 | 18.0 | Basic | Quarterly | 185.0 | 3.0 | 1.0 | 2 |
| 3 | 5.0 | 58.0 | Male | 38.0 | 21.0 | 7.0 | 7.0 | Standard | Monthly | 396.0 | 29.0 | 1.0 | 2 |
| 4 | 6.0 | 23.0 | Male | 32.0 | 20.0 | 5.0 | 8.0 | Basic | Monthly | 617.0 | 20.0 | 1.0 | 2 |
| 5 | 8.0 | 51.0 | Male | 33.0 | 25.0 | 9.0 | 26.0 | Premium | Annual | 129.0 | 8.0 | 1.0 | 2 |
| 6 | 9.0 | 58.0 | Female | 49.0 | 12.0 | 3.0 | 16.0 | Standard | Quarterly | 821.0 | 24.0 | 1.0 | 2 |
| 7 | 10.0 | 55.0 | Female | 37.0 | 8.0 | 4.0 | 15.0 | Premium | Annual | 445.0 | 30.0 | 1.0 | 2 |
| 8 | 11.0 | 39.0 | Male | 12.0 | 5.0 | 7.0 | 4.0 | Standard | Quarterly | 969.0 | 13.0 | 1.0 | 2 |
| 9 | 12.0 | 64.0 | Female | 3.0 | 25.0 | 2.0 | 11.0 | Standard | Quarterly | 415.0 | 29.0 | 1.0 | 2 |